# coding=utf-8
# 代码文件：chapter3/ch3.2.5.py

import xlwings as xw

app = xw.App(visible=False, add_book=False)
f = r'data/学生信息.xlsx'
wb = app.books.open(f)

sheet1 = wb.sheets['Sheet1']

rng1 = sheet1.range('A1').current_region

rng2 = rng1.options(transpose=True)         # 转置表格区域

L = rng2.value                              # 返回二维数组
print(" 打印二维数组L------------")
for x in L:
    print(x)

wb.close()
app.quit()

print('Game Over')